How to: Create a table using the 'Table Wizard' in Access.
Solution:
Click the 'Tables' tab in the Database window, click 'New', and select 'Table Wizard'.
NOTE: Never include a calculated field in the table.
1) If the Database window is not active, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Click 'New'. (The New Table dialog box appears.)
4) Select 'Table Wizard' from the list box.
5) Click 'OK'. (The Table Wizard dialog box appears.)
6) Select the type of table from the 'Sample Tables' list box. (The fields for the table appear in the Sample Fields list box.)
Sample Tables
7) Select the fields to include in the new table:
a) Select a field from the 'Sample Fields' list box.
Sample Fields
b) Click the '>' button. (The selected field appears in the 'Fields in my new table' box.)
c) Repeat steps 7)a) and 7)b) for each field to include in the new table.
8) Click 'Next'.
9) Type a name for the table in the 'What do you want to name your table?' box.
Type name
10) Select the desired radio button to specify whether or not the wizard sets the primary key.
Select radio button
11) Click 'Next'.
12) Select the tables that the new table is related to from the 'My new <table name> table is...' list box, where <table name> is the name typed in step 8).
Select relationships
NOTE: To create a relationship between two tables, select the table from the list box, click the 'Relationships..' button, select the desired radio button in the 'Relationships' dialog box, and click 'OK'. (The Table Wizard reappears.)
13) Click 'Next'.
14) Do one of the following to select what to do after the wizard creates the table:
Select view
a) Select the 'Modify the table design.' radio button to modify the table design.
b) Select the 'Enter data directly into the table' radio button to type data in a datasheet.
c) Select the 'Enter data into the table using a form the wizard creates for me.' radio button to type data in a form created by the wizard.
15) Click 'Finish'. (The table opens in whichever view was selected in step 14).)